Profiling Report

Dataset statistics

Number of variables	21
Number of observations	1296675
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	188.0 MiB
Average record size in memory	152.0 B

Variable types

Text	7
Categorical	4
Numeric	9
DateTime	1

Alerts

`merch_long` is highly overall correlated with `zip`	High correlation
`month` is highly overall correlated with `year`	High correlation
`unix_time` is highly overall correlated with `year`	High correlation
`year` is highly overall correlated with `month` and 1 other fields	High correlation
`zip` is highly overall correlated with `merch_long`	High correlation
`is_fraud` is highly imbalanced (94.9%)	Imbalance
`amt` is highly skewed (γ1 = 42.27787379)	Skewed
`day_of_week` has 254282 (19.6%) zeros	Zeros

Reproduction

Analysis started	2024-09-15 05:00:31.894384
Analysis finished	2024-09-15 05:01:33.691255
Duration	1 minute and 1.8 second
Software version	ydata-profiling vv4.10.0
Download configuration	config.json

merchant
Text

Distinct	693
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	9.9 MiB

Length

Max length	43
Median length	36
Mean length	23.132597
Min length	13

Characters and Unicode

Total characters	29995460
Distinct characters	55
Distinct categories	6 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	fraud_Rippin, Kub and Mann
2nd row	fraud_Heller, Gutmann and Zieme
3rd row	fraud_Lind-Buckridge
4th row	fraud_Kutch, Hermiston and Farrell
5th row	fraud_Keeling-Crist

Value	Count	Frequency (%)
and	474111	15.7%
llc	97780	3.2%
inc	91939	3.0%
sons	73145	2.4%
ltd	70853	2.3%
plc	66475	2.2%
group	50447	1.7%
fraud_kutch	10560	0.3%
fraud_schaefer	9394	0.3%
fraud_streich	9250	0.3%
Other values (804)	2069403	68.4%

Most occurring characters

Value	Count	Frequency (%)
a	2910697	9.7%
r	2695758	9.0%
d	2139780	7.1%
e	1865710	6.2%
u	1857912	6.2%
n	1768848	5.9%
	1726682	5.8%
f	1397378	4.7%
_	1296675	4.3%
o	1129340	3.8%
Other values (45)	11206680	37.4%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	22698472	75.7%
Uppercase Letter	3398527	11.3%
Space Separator	1726682	5.8%
Connector Punctuation	1296675	4.3%
Dash Punctuation	445070	1.5%
Other Punctuation	430034	1.4%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	2910697	12.8%
r	2695758	11.9%
d	2139780	9.4%
e	1865710	8.2%
u	1857912	8.2%
n	1768848	7.8%
f	1397378	6.2%
o	1129340	5.0%
i	1080395	4.8%
t	873637	3.8%
Other values (15)	4979017	21.9%

Uppercase Letter

Value	Count	Frequency (%)
L	477174	14.0%
C	312176	9.2%
S	301639	8.9%
B	278515	8.2%
H	260640	7.7%
K	216627	6.4%
G	192442	5.7%
R	181447	5.3%
M	179139	5.3%
P	159738	4.7%
Other values (15)	838990	24.7%

Other Punctuation

Value	Count	Frequency (%)
,	400966	93.2%
'	29068	6.8%

Space Separator

Value	Count	Frequency (%)
	1726682	100.0%

Connector Punctuation

Value	Count	Frequency (%)
_	1296675	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	445070	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	26096999	87.0%
Common	3898461	13.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	2910697	11.2%
r	2695758	10.3%
d	2139780	8.2%
e	1865710	7.1%
u	1857912	7.1%
n	1768848	6.8%
f	1397378	5.4%
o	1129340	4.3%
i	1080395	4.1%
t	873637	3.3%
Other values (40)	8377544	32.1%

Common

Value	Count	Frequency (%)
	1726682	44.3%
_	1296675	33.3%
-	445070	11.4%
,	400966	10.3%
'	29068	0.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	29995460	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	2910697	9.7%
r	2695758	9.0%
d	2139780	7.1%
e	1865710	6.2%
u	1857912	6.2%
n	1768848	5.9%
	1726682	5.8%
f	1397378	4.7%
_	1296675	4.3%
o	1129340	3.8%
Other values (45)	11206680	37.4%

category
Categorical

Distinct	14
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	9.9 MiB

gas_transport	131659
grocery_pos	123638
home	123115
shopping_pos	116672
kids_pets	113035
Other values (9)	688556

Length

Max length	14
Median length	12
Mean length	10.526079
Min length	4

Characters and Unicode

Total characters	13648903
Distinct characters	20
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	misc_net
2nd row	grocery_pos
3rd row	entertainment
4th row	gas_transport
5th row	misc_pos

Common Values

Value	Count	Frequency (%)
gas_transport	131659	10.2%
grocery_pos	123638	9.5%
home	123115	9.5%
shopping_pos	116672	9.0%
kids_pets	113035	8.7%
shopping_net	97543	7.5%
entertainment	94014	7.3%
food_dining	91461	7.1%
personal_care	90758	7.0%
health_fitness	85879	6.6%
Other values (4)	228901	17.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
gas_transport	131659	10.2%
grocery_pos	123638	9.5%
home	123115	9.5%
shopping_pos	116672	9.0%
kids_pets	113035	8.7%
shopping_net	97543	7.5%
entertainment	94014	7.3%
food_dining	91461	7.1%
personal_care	90758	7.0%
health_fitness	85879	6.6%
Other values (4)	228901	17.7%

Most occurring characters

Value	Count	Frequency (%)
s	1429026	10.5%
e	1287345	9.4%
o	1231724	9.0%
n	1193757	8.7%
p	1083847	7.9%
t	1076942	7.9%
_	1039039	7.6%
r	917535	6.7%
i	833007	6.1%
a	665234	4.9%
Other values (10)	2891447	21.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	12609864	92.4%
Connector Punctuation	1039039	7.6%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
s	1429026	11.3%
e	1287345	10.2%
o	1231724	9.8%
n	1193757	9.5%
p	1083847	8.6%
t	1076942	8.5%
r	917535	7.3%
i	833007	6.6%
a	665234	5.3%
g	606425	4.8%
Other values (9)	2285022	18.1%

Connector Punctuation

Value	Count	Frequency (%)
_	1039039	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	12609864	92.4%
Common	1039039	7.6%

Most frequent character per script

Latin

Value	Count	Frequency (%)
s	1429026	11.3%
e	1287345	10.2%
o	1231724	9.8%
n	1193757	9.5%
p	1083847	8.6%
t	1076942	8.5%
r	917535	7.3%
i	833007	6.6%
a	665234	5.3%
g	606425	4.8%
Other values (9)	2285022	18.1%

Common

Value	Count	Frequency (%)
_	1039039	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	13648903	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
s	1429026	10.5%
e	1287345	9.4%
o	1231724	9.0%
n	1193757	8.7%
p	1083847	7.9%
t	1076942	7.9%
_	1039039	7.6%
r	917535	6.7%
i	833007	6.1%
a	665234	4.9%
Other values (10)	2891447	21.2%

amt
Real number (ℝ)

SKEWED

Distinct	52928
Distinct (%)	4.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	70.351035

Minimum	1
Maximum	28948.9
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	9.9 MiB

Quantile statistics

Minimum	1
5-th percentile	2.44
Q1	9.65
median	47.52
Q3	83.14
95-th percentile	196.31
Maximum	28948.9
Range	28947.9
Interquartile range (IQR)	73.49

Descriptive statistics

Standard deviation	160.31604
Coefficient of variation (CV)	2.2788014
Kurtosis	4545.645
Mean	70.351035
Median Absolute Deviation (MAD)	37.5
Skewness	42.277874
Sum	91222429
Variance	25701.232
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1.14	542	< 0.1%
1.04	538	< 0.1%
1.25	535	< 0.1%
1.02	533	< 0.1%
1.01	523	< 0.1%
1.05	519	< 0.1%
1.2	516	< 0.1%
1.23	515	< 0.1%
1.08	512	< 0.1%
1.11	509	< 0.1%
Other values (52918)	1291433	99.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	222	< 0.1%
1.01	523	< 0.1%
1.02	533	< 0.1%
1.03	499	< 0.1%
1.04	538	< 0.1%
1.05	519	< 0.1%
1.06	471	< 0.1%
1.07	498	< 0.1%
1.08	512	< 0.1%
1.09	496	< 0.1%

Value	Count	Frequency (%)
28948.9	1	< 0.1%
27390.12	1	< 0.1%
27119.77	1	< 0.1%
26544.12	1	< 0.1%
25086.94	1	< 0.1%
17897.24	1	< 0.1%
15305.95	1	< 0.1%
15047.03	1	< 0.1%
15034.18	1	< 0.1%
14849.74	1	< 0.1%

first
Text

Distinct	352
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	9.9 MiB

Length

Max length	11
Median length	9
Mean length	6.0804319
Min length	3

Characters and Unicode

Total characters	7884344
Distinct characters	49
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Jennifer
2nd row	Stephanie
3rd row	Edward
4th row	Jeremy
5th row	Tyler

Value	Count	Frequency (%)
christopher	26669	2.1%
robert	21667	1.7%
jessica	20581	1.6%
james	20039	1.5%
michael	20009	1.5%
david	19965	1.5%
jennifer	16940	1.3%
william	16371	1.3%
mary	16346	1.3%
john	16325	1.3%
Other values (342)	1101763	85.0%

Most occurring characters

Value	Count	Frequency (%)
a	1007700	12.8%
e	860878	10.9%
i	618247	7.8%
n	614453	7.8%
r	607072	7.7%
l	388220	4.9%
h	344993	4.4%
s	324237	4.1%
t	311569	4.0%
o	268849	3.4%
Other values (39)	2538126	32.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	6587669	83.6%
Uppercase Letter	1296675	16.4%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	1007700	15.3%
e	860878	13.1%
i	618247	9.4%
n	614453	9.3%
r	607072	9.2%
l	388220	5.9%
h	344993	5.2%
s	324237	4.9%
t	311569	4.7%
o	268849	4.1%
Other values (16)	1241451	18.8%

Uppercase Letter

Value	Count	Frequency (%)
J	218907	16.9%
M	144916	11.2%
S	114469	8.8%
A	112464	8.7%
C	106121	8.2%
D	86078	6.6%
K	85426	6.6%
R	70457	5.4%
T	66590	5.1%
L	62879	4.8%
Other values (13)	228368	17.6%

Most occurring scripts

Value	Count	Frequency (%)
Latin	7884344	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	1007700	12.8%
e	860878	10.9%
i	618247	7.8%
n	614453	7.8%
r	607072	7.7%
l	388220	4.9%
h	344993	4.4%
s	324237	4.1%
t	311569	4.0%
o	268849	3.4%
Other values (39)	2538126	32.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	7884344	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	1007700	12.8%
e	860878	10.9%
i	618247	7.8%
n	614453	7.8%
r	607072	7.7%
l	388220	4.9%
h	344993	4.4%
s	324237	4.1%
t	311569	4.0%
o	268849	3.4%
Other values (39)	2538126	32.2%

last
Text

Distinct	481
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	9.9 MiB

Length

Max length	11
Median length	10
Mean length	6.1111774
Min length	2

Characters and Unicode

Total characters	7924211
Distinct characters	48
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Banks
2nd row	Gill
3rd row	Sanchez
4th row	White
5th row	Garcia

Value	Count	Frequency (%)
smith	28794	2.2%
williams	23605	1.8%
davis	21910	1.7%
johnson	20034	1.5%
rodriguez	17394	1.3%
martinez	14805	1.1%
jones	13976	1.1%
lewis	12753	1.0%
gonzalez	11799	0.9%
miller	11698	0.9%
Other values (471)	1119907	86.4%

Most occurring characters

Value	Count	Frequency (%)
e	786302	9.9%
r	658748	8.3%
a	648005	8.2%
n	609178	7.7%
o	583517	7.4%
l	489180	6.2%
s	487668	6.2%
i	435378	5.5%
t	288591	3.6%
h	228981	2.9%
Other values (38)	2708663	34.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	6627536	83.6%
Uppercase Letter	1296675	16.4%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	786302	11.9%
r	658748	9.9%
a	648005	9.8%
n	609178	9.2%
o	583517	8.8%
l	489180	7.4%
s	487668	7.4%
i	435378	6.6%
t	288591	4.4%
h	228981	3.5%
Other values (15)	1411988	21.3%

Uppercase Letter

Value	Count	Frequency (%)
M	158701	12.2%
W	106490	8.2%
S	105221	8.1%
C	93308	7.2%
B	84092	6.5%
R	83194	6.4%
H	81444	6.3%
G	75241	5.8%
J	71781	5.5%
P	66087	5.1%
Other values (13)	371116	28.6%

Most occurring scripts

Value	Count	Frequency (%)
Latin	7924211	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	786302	9.9%
r	658748	8.3%
a	648005	8.2%
n	609178	7.7%
o	583517	7.4%
l	489180	6.2%
s	487668	6.2%
i	435378	5.5%
t	288591	3.6%
h	228981	2.9%
Other values (38)	2708663	34.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	7924211	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	786302	9.9%
r	658748	8.3%
a	648005	8.2%
n	609178	7.7%
o	583517	7.4%
l	489180	6.2%
s	487668	6.2%
i	435378	5.5%
t	288591	3.6%
h	228981	2.9%
Other values (38)	2708663	34.2%

gender
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	9.9 MiB

F	709863
M	586812

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	1296675
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	F
2nd row	F
3rd row	M
4th row	M
5th row	M

Common Values

Value	Count	Frequency (%)
F	709863	54.7%
M	586812	45.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
f	709863	54.7%
m	586812	45.3%

Most occurring characters

Value	Count	Frequency (%)
F	709863	54.7%
M	586812	45.3%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	1296675	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
F	709863	54.7%
M	586812	45.3%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1296675	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
F	709863	54.7%
M	586812	45.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1296675	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
F	709863	54.7%
M	586812	45.3%

street
Text

Distinct	983
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	9.9 MiB

Length

Max length	35
Median length	29
Mean length	22.229027
Min length	12

Characters and Unicode

Total characters	28823823
Distinct characters	62
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	561 Perry Cove
2nd row	43039 Riley Greens Suite 393
3rd row	594 White Dale Suite 530
4th row	9443 Cynthia Court Apt. 038
5th row	408 Bradley Rest

Value	Count	Frequency (%)
apt	327791	6.4%
suite	305467	5.9%
island	22954	0.4%
michael	18967	0.4%
common	17978	0.3%
station	17957	0.3%
islands	17917	0.3%
david	17476	0.3%
brooks	16991	0.3%
fields	16321	0.3%
Other values (1940)	4376722	84.9%

Most occurring characters

Value	Count	Frequency (%)
	3859866	13.4%
e	1792676	6.2%
a	1454190	5.0%
i	1296969	4.5%
t	1248091	4.3%
r	1103208	3.8%
n	1066149	3.7%
s	1034564	3.6%
l	889594	3.1%
o	875571	3.0%
Other values (52)	14202945	49.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	14413030	50.0%
Decimal Number	6996528	24.3%
Space Separator	3859866	13.4%
Uppercase Letter	3226608	11.2%
Other Punctuation	327791	1.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	1792676	12.4%
a	1454190	10.1%
i	1296969	9.0%
t	1248091	8.7%
r	1103208	7.7%
n	1066149	7.4%
s	1034564	7.2%
l	889594	6.2%
o	875571	6.1%
u	613916	4.3%
Other values (16)	3038102	21.1%

Uppercase Letter

Value	Count	Frequency (%)
S	561924	17.4%
A	421707	13.1%
M	258180	8.0%
C	223839	6.9%
P	195864	6.1%
R	186303	5.8%
B	148676	4.6%
F	143149	4.4%
L	131665	4.1%
J	121164	3.8%
Other values (14)	834137	25.9%

Decimal Number

Value	Count	Frequency (%)
5	748812	10.7%
3	739928	10.6%
2	734719	10.5%
7	703124	10.0%
1	693880	9.9%
8	692585	9.9%
6	677709	9.7%
0	677245	9.7%
4	669799	9.6%
9	658727	9.4%

Space Separator

Value	Count	Frequency (%)
	3859866	100.0%

Other Punctuation

Value	Count	Frequency (%)
.	327791	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	17639638	61.2%
Common	11184185	38.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	1792676	10.2%
a	1454190	8.2%
i	1296969	7.4%
t	1248091	7.1%
r	1103208	6.3%
n	1066149	6.0%
s	1034564	5.9%
l	889594	5.0%
o	875571	5.0%
u	613916	3.5%
Other values (40)	6264710	35.5%

Common

Value	Count	Frequency (%)
	3859866	34.5%
5	748812	6.7%
3	739928	6.6%
2	734719	6.6%
7	703124	6.3%
1	693880	6.2%
8	692585	6.2%
6	677709	6.1%
0	677245	6.1%
4	669799	6.0%
Other values (2)	986518	8.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	28823823	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	3859866	13.4%
e	1792676	6.2%
a	1454190	5.0%
i	1296969	4.5%
t	1248091	4.3%
r	1103208	3.8%
n	1066149	3.7%
s	1034564	3.6%
l	889594	3.1%
o	875571	3.0%
Other values (52)	14202945	49.3%

city
Text

Distinct	894
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	9.9 MiB

Length

Max length	25
Median length	21
Mean length	8.6522459
Min length	3

Characters and Unicode

Total characters	11219151
Distinct characters	52
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Moravian Falls
2nd row	Orient
3rd row	Malad City
4th row	Boulder
5th row	Doe Hill

Value	Count	Frequency (%)
city	21314	1.3%
west	19473	1.2%
north	14425	0.9%
saint	14363	0.9%
falls	12794	0.8%
new	11842	0.7%
mount	11375	0.7%
lake	11249	0.7%
san	10260	0.6%
springs	8727	0.5%
Other values (918)	1482445	91.6%

Most occurring characters

Value	Count	Frequency (%)
e	1090254	9.7%
a	935089	8.3%
n	821831	7.3%
o	817806	7.3%
l	781662	7.0%
r	748921	6.7%
i	704285	6.3%
t	598490	5.3%
s	446306	4.0%
	321592	2.9%
Other values (42)	3952915	35.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	9277246	82.7%
Uppercase Letter	1619290	14.4%
Space Separator	321592	2.9%
Dash Punctuation	1023	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	1090254	11.8%
a	935089	10.1%
n	821831	8.9%
o	817806	8.8%
l	781662	8.4%
r	748921	8.1%
i	704285	7.6%
t	598490	6.5%
s	446306	4.8%
d	309005	3.3%
Other values (15)	2023597	21.8%

Uppercase Letter

Value	Count	Frequency (%)
C	156587	9.7%
M	147711	9.1%
S	136036	8.4%
B	133396	8.2%
H	115641	7.1%
W	95433	5.9%
P	92084	5.7%
L	86511	5.3%
R	79150	4.9%
A	74999	4.6%
Other values (15)	501742	31.0%

Space Separator

Value	Count	Frequency (%)
	321592	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	1023	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	10896536	97.1%
Common	322615	2.9%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	1090254	10.0%
a	935089	8.6%
n	821831	7.5%
o	817806	7.5%
l	781662	7.2%
r	748921	6.9%
i	704285	6.5%
t	598490	5.5%
s	446306	4.1%
d	309005	2.8%
Other values (40)	3642887	33.4%

Common

Value	Count	Frequency (%)
	321592	99.7%
-	1023	0.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	11219151	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	1090254	9.7%
a	935089	8.3%
n	821831	7.3%
o	817806	7.3%
l	781662	7.0%
r	748921	6.7%
i	704285	6.3%
t	598490	5.3%
s	446306	4.0%
	321592	2.9%
Other values (42)	3952915	35.2%

state
Text

Distinct	51
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	9.9 MiB

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	2593350
Distinct characters	24
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	NC
2nd row	WA
3rd row	ID
4th row	MT
5th row	VA

Value	Count	Frequency (%)
tx	94876	7.3%
ny	83501	6.4%
pa	79847	6.2%
ca	56360	4.3%
oh	46480	3.6%
mi	46154	3.6%
il	43252	3.3%
fl	42671	3.3%
al	40989	3.2%
mo	38403	3.0%
Other values (41)	724142	55.8%

Most occurring characters

Value	Count	Frequency (%)
A	355776	13.7%
N	284464	11.0%
M	220694	8.5%
I	181993	7.0%
T	154353	6.0%
L	147877	5.7%
O	144031	5.6%
C	141011	5.4%
Y	131298	5.1%
X	94876	3.7%
Other values (14)	736977	28.4%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	2593350	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	355776	13.7%
N	284464	11.0%
M	220694	8.5%
I	181993	7.0%
T	154353	6.0%
L	147877	5.7%
O	144031	5.6%
C	141011	5.4%
Y	131298	5.1%
X	94876	3.7%
Other values (14)	736977	28.4%

Most occurring scripts

Value	Count	Frequency (%)
Latin	2593350	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	355776	13.7%
N	284464	11.0%
M	220694	8.5%
I	181993	7.0%
T	154353	6.0%
L	147877	5.7%
O	144031	5.6%
C	141011	5.4%
Y	131298	5.1%
X	94876	3.7%
Other values (14)	736977	28.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2593350	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	355776	13.7%
N	284464	11.0%
M	220694	8.5%
I	181993	7.0%
T	154353	6.0%
L	147877	5.7%
O	144031	5.6%
C	141011	5.4%
Y	131298	5.1%
X	94876	3.7%
Other values (14)	736977	28.4%

zip
Real number (ℝ)

HIGH CORRELATION

Distinct	970
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	48800.671

Minimum	1257
Maximum	99783
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	9.9 MiB

Quantile statistics

Minimum	1257
5-th percentile	7208
Q1	26237
median	48174
Q3	72042
95-th percentile	94569
Maximum	99783
Range	98526
Interquartile range (IQR)	45805

Descriptive statistics

Standard deviation	26893.222
Coefficient of variation (CV)	0.55108305
Kurtosis	-1.0964493
Mean	48800.671
Median Absolute Deviation (MAD)	23068
Skewness	0.079680758
Sum	6.327861 × 10¹⁰
Variance	7.2324542 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
73754	3646	0.3%
34112	3613	0.3%
48088	3597	0.3%
82514	3527	0.3%
49628	3123	0.2%
15484	3123	0.2%
85173	3119	0.2%
29819	3117	0.2%
38761	3113	0.2%
5461	3112	0.2%
Other values (960)	1263585	97.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1257	2023	0.2%
1330	1031	0.1%
1535	515	< 0.1%
1545	1024	0.1%
1612	519	< 0.1%
1843	2597	0.2%
1844	2058	0.2%
2180	519	< 0.1%
2630	2090	0.2%
2908	550	< 0.1%

Value	Count	Frequency (%)
99783	1568	0.1%
99747	12	< 0.1%
99746	540	< 0.1%
99323	2572	0.2%
99160	3030	0.2%
99116	15	< 0.1%
99113	1047	0.1%
99033	2458	0.2%
98836	524	< 0.1%
98665	500	< 0.1%

city_pop
Real number (ℝ)

Distinct	879
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	88824.441

Minimum	23
Maximum	2906700
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	9.9 MiB

Quantile statistics

Minimum	23
5-th percentile	139
Q1	743
median	2456
Q3	20328
95-th percentile	525713
Maximum	2906700
Range	2906677
Interquartile range (IQR)	19585

Descriptive statistics

Standard deviation	301956.36
Coefficient of variation (CV)	3.3994738
Kurtosis	37.614519
Mean	88824.441
Median Absolute Deviation (MAD)	2198
Skewness	5.5938531
Sum	1.1517643 × 10¹¹
Variance	9.1177644 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
606	5496	0.4%
1595797	5130	0.4%
1312922	5075	0.4%
1766	4574	0.4%
241	4533	0.3%
2906700	4168	0.3%
276002	4155	0.3%
302	4147	0.3%
910148	4073	0.3%
198	4067	0.3%
Other values (869)	1251257	96.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
23	2049	0.2%
37	1013	0.1%
43	2034	0.2%
46	3040	0.2%
47	511	< 0.1%
49	1054	0.1%
51	1016	0.1%
52	518	< 0.1%
53	2610	0.2%
60	1045	0.1%

Value	Count	Frequency (%)
2906700	4168	0.3%
2504700	2033	0.2%
2383912	521	< 0.1%
1595797	5130	0.4%
1577385	2563	0.2%
1526206	3517	0.3%
1417793	8	< 0.1%
1382480	2056	0.2%
1312922	5075	0.4%
1263321	3629	0.3%

job
Text

Distinct	494
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	9.9 MiB

Length

Max length	59
Median length	38
Mean length	20.227102
Min length	3

Characters and Unicode

Total characters	26227978
Distinct characters	53
Distinct categories	6 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Psychologist, counselling
2nd row	Special educational needs teacher
3rd row	Nature conservation officer
4th row	Patent attorney
5th row	Dance movement psychotherapist

Value	Count	Frequency (%)
engineer	131756	4.6%
officer	110915	3.9%
manager	61124	2.1%
scientist	55878	1.9%
designer	52218	1.8%
surveyor	49062	1.7%
teacher	38126	1.3%
psychologist	32600	1.1%
research	29754	1.0%
editor	28725	1.0%
Other values (456)	2289024	79.5%

Most occurring characters

Value	Count	Frequency (%)
e	2803032	10.7%
i	2386346	9.1%
r	2198669	8.4%
a	1813638	6.9%
t	1782302	6.8%
n	1764769	6.7%
	1582507	6.0%
o	1491775	5.7%
s	1444701	5.5%
c	1323152	5.0%
Other values (43)	7637087	29.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	22784440	86.9%
Space Separator	1582507	6.0%
Uppercase Letter	1369269	5.2%
Other Punctuation	443484	1.7%
Close Punctuation	24139	0.1%
Open Punctuation	24139	0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	2803032	12.3%
i	2386346	10.5%
r	2198669	9.6%
a	1813638	8.0%
t	1782302	7.8%
n	1764769	7.7%
o	1491775	6.5%
s	1444701	6.3%
c	1323152	5.8%
l	999624	4.4%
Other values (16)	4776432	21.0%

Uppercase Letter

Value	Count	Frequency (%)
C	156704	11.4%
E	145426	10.6%
P	143111	10.5%
S	137500	10.0%
T	113148	8.3%
M	89545	6.5%
A	88466	6.5%
F	68651	5.0%
D	58034	4.2%
R	55841	4.1%
Other values (11)	312843	22.8%

Other Punctuation

Value	Count	Frequency (%)
,	312210	70.4%
/	123567	27.9%
'	7707	1.7%

Space Separator

Value	Count	Frequency (%)
	1582507	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	24139	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	24139	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	24153709	92.1%
Common	2074269	7.9%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	2803032	11.6%
i	2386346	9.9%
r	2198669	9.1%
a	1813638	7.5%
t	1782302	7.4%
n	1764769	7.3%
o	1491775	6.2%
s	1444701	6.0%
c	1323152	5.5%
l	999624	4.1%
Other values (37)	6145701	25.4%

Common

Value	Count	Frequency (%)
	1582507	76.3%
,	312210	15.1%
/	123567	6.0%
)	24139	1.2%
(	24139	1.2%
'	7707	0.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	26227978	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	2803032	10.7%
i	2386346	9.1%
r	2198669	8.4%
a	1813638	6.9%
t	1782302	6.8%
n	1764769	6.7%
	1582507	6.0%
o	1491775	5.7%
s	1444701	5.5%
c	1323152	5.0%
Other values (43)	7637087	29.1%

dob
Date

Distinct	968
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	9.9 MiB

Minimum	1924-10-30 00:00:00
Maximum	2005-01-29 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

unix_time
Real number (ℝ)

HIGH CORRELATION

Distinct	1274823
Distinct (%)	98.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.3492436 × 10⁹

Minimum	1.325376 × 10⁹
Maximum	1.3718168 × 10⁹
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	9.9 MiB

Quantile statistics

Minimum	1.325376 × 10⁹
5-th percentile	1.328672 × 10⁹
Q1	1.3387507 × 10⁹
median	1.3492497 × 10⁹
Q3	1.3593854 × 10⁹
95-th percentile	1.3698306 × 10⁹
Maximum	1.3718168 × 10⁹
Range	46440799
Interquartile range (IQR)	20634633

Descriptive statistics

Standard deviation	12841278
Coefficient of variation (CV)	0.0095173904
Kurtosis	-1.0875405
Mean	1.3492436 × 10⁹
Median Absolute Deviation (MAD)	10358807
Skewness	0.0033779498
Sum	1.7495305 × 10¹⁵
Variance	1.6489843 × 10¹⁴
Monotonicity	Increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1370177227	4	< 0.1%
1335110521	4	< 0.1%
1370050667	4	< 0.1%
1367602155	3	< 0.1%
1364686521	3	< 0.1%
1369587838	3	< 0.1%
1337306743	3	< 0.1%
1343668520	3	< 0.1%
1341944714	3	< 0.1%
1340650327	3	< 0.1%
Other values (1274813)	1296642	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1325376018	1	< 0.1%
1325376044	1	< 0.1%
1325376051	1	< 0.1%
1325376076	1	< 0.1%
1325376186	1	< 0.1%
1325376248	1	< 0.1%
1325376282	1	< 0.1%
1325376308	1	< 0.1%
1325376318	1	< 0.1%
1325376361	1	< 0.1%

Value	Count	Frequency (%)
1371816817	1	< 0.1%
1371816816	1	< 0.1%
1371816752	1	< 0.1%
1371816739	1	< 0.1%
1371816728	1	< 0.1%
1371816696	1	< 0.1%
1371816683	1	< 0.1%
1371816656	1	< 0.1%
1371816562	1	< 0.1%
1371816522	1	< 0.1%

merch_lat
Real number (ℝ)

Distinct	1247805
Distinct (%)	96.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	38.537338

Minimum	19.027785
Maximum	67.510267
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	9.9 MiB

Quantile statistics

Minimum	19.027785
5-th percentile	29.751653
Q1	34.733572
median	39.36568
Q3	41.957164
95-th percentile	46.00353
Maximum	67.510267
Range	48.482482
Interquartile range (IQR)	7.223592

Descriptive statistics

Standard deviation	5.1097884
Coefficient of variation (CV)	0.13259318
Kurtosis	0.79599391
Mean	38.537338
Median Absolute Deviation (MAD)	3.397536
Skewness	-0.18191543
Sum	49970403
Variance	26.109937
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
41.305966	4	< 0.1%
41.937796	4	< 0.1%
42.265012	4	< 0.1%
41.301611	4	< 0.1%
34.134994	4	< 0.1%
37.669788	4	< 0.1%
39.348185	4	< 0.1%
32.64469	4	< 0.1%
42.749184	4	< 0.1%
38.050673	4	< 0.1%
Other values (1247795)	1296635	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
19.027785	1	< 0.1%
19.027804	1	< 0.1%
19.029798	1	< 0.1%
19.031242	1	< 0.1%
19.032277	1	< 0.1%
19.033288	1	< 0.1%
19.034282	1	< 0.1%
19.034687	1	< 0.1%
19.035472	1	< 0.1%
19.036312	1	< 0.1%

Value	Count	Frequency (%)
67.510267	1	< 0.1%
67.441518	1	< 0.1%
67.397018	1	< 0.1%
67.188111	1	< 0.1%
67.064277	1	< 0.1%
66.835174	1	< 0.1%
66.682905	1	< 0.1%
66.67355	1	< 0.1%
66.664673	1	< 0.1%
66.659242	1	< 0.1%

merch_long
Real number (ℝ)

HIGH CORRELATION

Distinct	1275745
Distinct (%)	98.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-90.226465

Minimum	-166.67124
Maximum	-66.950902
Zeros	0
Zeros (%)	0.0%
Negative	1296675
Negative (%)	100.0%
Memory size	9.9 MiB

Quantile statistics

Minimum	-166.67124
5-th percentile	-119.33009
Q1	-96.897276
median	-87.438392
Q3	-80.236796
95-th percentile	-73.354218
Maximum	-66.950902
Range	99.72034
Interquartile range (IQR)	16.660479

Descriptive statistics

Standard deviation	13.771091
Coefficient of variation (CV)	-0.15262806
Kurtosis	1.8484792
Mean	-90.226465
Median Absolute Deviation (MAD)	8.227889
Skewness	-1.1469599
Sum	-1.169944 × 10⁸
Variance	189.64294
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-87.116414	4	< 0.1%
-81.219189	4	< 0.1%
-74.618269	4	< 0.1%
-85.326323	3	< 0.1%
-84.890305	3	< 0.1%
-88.49309	3	< 0.1%
-84.100102	3	< 0.1%
-97.527227	3	< 0.1%
-85.3444	3	< 0.1%
-86.037494	3	< 0.1%
Other values (1275735)	1296642	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-166.671242	1	< 0.1%
-166.670132	1	< 0.1%
-166.669638	1	< 0.1%
-166.666179	1	< 0.1%
-166.664828	1	< 0.1%
-166.662888	1	< 0.1%
-166.661968	1	< 0.1%
-166.659277	1	< 0.1%
-166.657834	1	< 0.1%
-166.657174	1	< 0.1%

Value	Count	Frequency (%)
-66.950902	1	< 0.1%
-66.955996	1	< 0.1%
-66.95654	1	< 0.1%
-66.958659	1	< 0.1%
-66.958751	1	< 0.1%
-66.959178	1	< 0.1%
-66.961923	1	< 0.1%
-66.962913	1	< 0.1%
-66.963918	1	< 0.1%
-66.963975	1	< 0.1%

is_fraud
Categorical

IMBALANCE

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	9.9 MiB

0	1289169
1	7506

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	1296675
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	1289169	99.4%
1	7506	0.6%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	1289169	99.4%
1	7506	0.6%

Most occurring characters

Value	Count	Frequency (%)
0	1289169	99.4%
1	7506	0.6%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1296675	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	1289169	99.4%
1	7506	0.6%

Most occurring scripts

Value	Count	Frequency (%)
Common	1296675	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	1289169	99.4%
1	7506	0.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1296675	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	1289169	99.4%
1	7506	0.6%

year
Categorical

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	9.9 MiB

2019	924850
2020	371825

Length

Max length	4
Median length	4
Mean length	4
Min length	4

Characters and Unicode

Total characters	5186700
Distinct characters	4
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2019
2nd row	2019
3rd row	2019
4th row	2019
5th row	2019

Common Values

Value	Count	Frequency (%)
2019	924850	71.3%
2020	371825	28.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2019	924850	71.3%
2020	371825	28.7%

Most occurring characters

Value	Count	Frequency (%)
2	1668500	32.2%
0	1668500	32.2%
1	924850	17.8%
9	924850	17.8%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	5186700	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
2	1668500	32.2%
0	1668500	32.2%
1	924850	17.8%
9	924850	17.8%

Most occurring scripts

Value	Count	Frequency (%)
Common	5186700	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
2	1668500	32.2%
0	1668500	32.2%
1	924850	17.8%
9	924850	17.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	5186700	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
2	1668500	32.2%
0	1668500	32.2%
1	924850	17.8%
9	924850	17.8%

month
Real number (ℝ)

HIGH CORRELATION

Distinct	12
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.1421497

Minimum	1
Maximum	12
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.9 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	3
median	6
Q3	9
95-th percentile	12
Maximum	12
Range	11
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	3.4177033
Coefficient of variation (CV)	0.55643439
Kurtosis	-1.0475463
Mean	6.1421497
Median Absolute Deviation (MAD)	3
Skewness	0.29851575
Sum	7964372
Variance	11.680696
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
5	146875	11.3%
6	143811	11.1%
3	143789	11.1%
12	141060	10.9%
4	134970	10.4%
1	104727	8.1%
2	97657	7.5%
8	87359	6.7%
7	86596	6.7%
9	70652	5.4%
Other values (2)	139179	10.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	104727	8.1%
2	97657	7.5%
3	143789	11.1%
4	134970	10.4%
5	146875	11.3%
6	143811	11.1%
7	86596	6.7%
8	87359	6.7%
9	70652	5.4%
10	68758	5.3%

Value	Count	Frequency (%)
12	141060	10.9%
11	70421	5.4%
10	68758	5.3%
9	70652	5.4%
8	87359	6.7%
7	86596	6.7%
6	143811	11.1%
5	146875	11.3%
4	134970	10.4%
3	143789	11.1%

day
Real number (ℝ)

Distinct	31
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15.587978

Minimum	1
Maximum	31
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.9 MiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	8
median	15
Q3	23
95-th percentile	30
Maximum	31
Range	30
Interquartile range (IQR)	15

Descriptive statistics

Standard deviation	8.8291214
Coefficient of variation (CV)	0.5664058
Kurtosis	-1.1871417
Mean	15.587978
Median Absolute Deviation (MAD)	8
Skewness	0.030847364
Sum	20212542
Variance	77.953384
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=31)

Value	Count	Frequency (%)
1	47089	3.6%
15	46213	3.6%
8	46201	3.6%
16	44894	3.5%
2	44748	3.5%
9	44685	3.4%
7	44239	3.4%
14	44015	3.4%
28	43470	3.4%
17	42272	3.3%
Other values (21)	848849	65.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	47089	3.6%
2	44748	3.5%
3	41842	3.2%
4	41479	3.2%
5	41886	3.2%
6	41420	3.2%
7	44239	3.4%
8	46201	3.6%
9	44685	3.4%
10	41934	3.2%

Value	Count	Frequency (%)
31	24701	1.9%
30	41019	3.2%
29	39617	3.1%
28	43470	3.4%
27	39684	3.1%
26	40692	3.1%
25	40374	3.1%
24	41360	3.2%
23	40815	3.1%
22	42061	3.2%

day_of_week
Real number (ℝ)

ZEROS

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.0706037

Minimum	0
Maximum	6
Zeros	254282
Zeros (%)	19.6%
Negative	0
Negative (%)	0.0%
Memory size	4.9 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	3
Q3	5
95-th percentile	6
Maximum	6
Range	6
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	2.1981526
Coefficient of variation (CV)	0.71586984
Kurtosis	-1.445049
Mean	3.0706037
Median Absolute Deviation (MAD)	2
Skewness	-0.078453041
Sum	3981575
Variance	4.8318747
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
0	254282	19.6%
6	250579	19.3%
5	200957	15.5%
1	160227	12.4%
4	152272	11.7%
3	147285	11.4%
2	131073	10.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	254282	19.6%
1	160227	12.4%
2	131073	10.1%
3	147285	11.4%
4	152272	11.7%
5	200957	15.5%
6	250579	19.3%

Value	Count	Frequency (%)
6	250579	19.3%
5	200957	15.5%
4	152272	11.7%
3	147285	11.4%
2	131073	10.1%
1	160227	12.4%
0	254282	19.6%

Auto

Heatmap
Table

	amt	category	city_pop	day	day_of_week	gender	is_fraud	merch_lat	merch_long	month	unix_time	year	zip
amt	1.000	0.020	-0.024	0.000	-0.001	0.000	0.000	0.012	0.000	-0.003	0.001	0.000	0.001
category	0.020	1.000	0.014	0.001	0.003	0.054	0.071	0.011	0.009	0.001	0.001	0.000	0.011
city_pop	-0.024	0.014	1.000	-0.001	0.002	0.089	0.004	-0.264	0.086	0.001	-0.003	0.001	-0.040
day	0.000	0.001	-0.001	1.000	0.017	0.000	0.009	-0.000	0.000	0.008	0.019	0.057	-0.001
day_of_week	-0.001	0.003	0.002	0.017	1.000	0.006	0.012	0.000	0.001	0.038	-0.029	0.090	-0.001
gender	0.000	0.054	0.089	0.000	0.006	1.000	0.008	0.103	0.082	0.002	0.000	0.000	0.119
is_fraud	0.000	0.071	0.004	0.009	0.012	0.008	1.000	0.008	0.005	0.018	0.018	0.003	0.005
merch_lat	0.012	0.011	-0.264	-0.000	0.000	0.103	0.008	1.000	0.104	-0.001	0.001	0.000	-0.162
merch_long	0.000	0.009	0.086	0.000	0.001	0.082	0.005	0.104	1.000	-0.001	-0.001	0.000	-0.957
month	-0.003	0.001	0.001	0.008	0.038	0.002	0.018	-0.001	-0.001	1.000	0.173	0.527	0.001
unix_time	0.001	0.001	-0.003	0.019	-0.029	0.000	0.018	0.001	-0.001	0.173	1.000	0.971	0.001
year	0.000	0.000	0.001	0.057	0.090	0.000	0.003	0.000	0.000	0.527	0.971	1.000	0.002
zip	0.001	0.011	-0.040	-0.001	-0.001	0.119	0.005	-0.162	-0.957	0.001	0.001	0.002	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	merchant	category	amt	first	last	gender	street	city	state	zip	city_pop	job	dob	unix_time	merch_lat	merch_long	year	month	day	day_of_week
0	fraud_Rippin, Kub and Mann	misc_net	4.97	Jennifer	Banks	F	561 Perry Cove	Moravian Falls	NC	28654	3495	Psychologist, counselling	1988-03-09	1325376018	36.011293	-82.048315	2019	1	1	1
1	fraud_Heller, Gutmann and Zieme	grocery_pos	107.23	Stephanie	Gill	F	43039 Riley Greens Suite 393	Orient	WA	99160	149	Special educational needs teacher	1978-06-21	1325376044	49.159047	-118.186462	2019	1	1	1
2	fraud_Lind-Buckridge	entertainment	220.11	Edward	Sanchez	M	594 White Dale Suite 530	Malad City	ID	83252	4154	Nature conservation officer	1962-01-19	1325376051	43.150704	-112.154481	2019	1	1	1
3	fraud_Kutch, Hermiston and Farrell	gas_transport	45.00	Jeremy	White	M	9443 Cynthia Court Apt. 038	Boulder	MT	59632	1939	Patent attorney	1967-01-12	1325376076	47.034331	-112.561071	2019	1	1	1
4	fraud_Keeling-Crist	misc_pos	41.96	Tyler	Garcia	M	408 Bradley Rest	Doe Hill	VA	24433	99	Dance movement psychotherapist	1986-03-28	1325376186	38.674999	-78.632459	2019	1	1	1
5	fraud_Stroman, Hudson and Erdman	gas_transport	94.63	Jennifer	Conner	F	4655 David Island	Dublin	PA	18917	2158	Transport planner	1961-06-19	1325376248	40.653382	-76.152667	2019	1	1	1
6	fraud_Rowe-Vandervort	grocery_net	44.54	Kelsey	Richards	F	889 Sarah Station Suite 624	Holcomb	KS	67851	2691	Arboriculturist	1993-08-16	1325376282	37.162705	-100.153370	2019	1	1	1
7	fraud_Corwin-Collins	gas_transport	71.65	Steven	Williams	M	231 Flores Pass Suite 720	Edinburg	VA	22824	6018	Designer, multimedia	1947-08-21	1325376308	38.948089	-78.540296	2019	1	1	1
8	fraud_Herzog Ltd	misc_pos	4.27	Heather	Chase	F	6888 Hicks Stream Suite 954	Manor	PA	15665	1472	Public affairs consultant	1941-03-07	1325376318	40.351813	-79.958146	2019	1	1	1
9	fraud_Schoen, Kuphal and Nitzsche	grocery_pos	198.39	Melissa	Aguilar	F	21326 Taylor Squares Suite 708	Clarksville	TN	37040	151785	Pathologist	1974-03-28	1325376361	37.179198	-87.485381	2019	1	1	1

	merchant	category	amt	first	last	gender	street	city	state	zip	city_pop	job	dob	unix_time	merch_lat	merch_long	year	month	day	day_of_week
1296665	fraud_Gulgowski LLC	home	72.17	James	Hunt	M	7369 Gabriel Tunnel	Pointe Aux Pins	MI	49775	95	Electrical engineer	1994-02-09	1371816522	44.938461	-83.996234	2020	6	21	6
1296666	fraud_Hyatt, Russel and Gleichner	health_fitness	7.30	Amber	Lewis	F	6296 John Keys Suite 858	Pembroke Township	IL	60958	2135	Psychotherapist, child	2004-05-08	1371816562	40.556811	-88.092339	2020	6	21	6
1296667	fraud_Hahn, Douglas and Schowalter	travel	19.71	Christopher	Farrell	M	97070 Anderson Land	Haines City	FL	33844	33804	Exercise physiologist	1991-01-01	1371816656	27.465871	-81.511804	2020	6	21	6
1296668	fraud_Metz, Russel and Metz	kids_pets	100.85	Margaret	Curtis	F	742 Oneill Shore	Florence	MS	39073	19685	Fine artist	1984-12-24	1371816683	31.377697	-90.528450	2020	6	21	6
1296669	fraud_Stiedemann Inc	misc_pos	37.38	Marissa	Powell	F	474 Allen Haven	North Loup	NE	68859	509	Nurse, children's	1980-09-15	1371816696	41.728638	-99.039660	2020	6	21	6
1296670	fraud_Reichel Inc	entertainment	15.56	Erik	Patterson	M	162 Jessica Row Apt. 072	Hatch	UT	84735	258	Geoscientist	1961-11-24	1371816728	36.841266	-111.690765	2020	6	21	6
1296671	fraud_Abernathy and Sons	food_dining	51.70	Jeffrey	White	M	8617 Holmes Terrace Suite 651	Tuscarora	MD	21790	100	Production assistant, television	1979-12-11	1371816739	38.906881	-78.246528	2020	6	21	6
1296672	fraud_Stiedemann Ltd	food_dining	105.93	Christopher	Castaneda	M	1632 Cohen Drive Suite 639	High Rolls Mountain Park	NM	88325	899	Naval architect	1967-08-30	1371816752	33.619513	-105.130529	2020	6	21	6
1296673	fraud_Reinger, Weissnat and Strosin	food_dining	74.90	Joseph	Murray	M	42933 Ryan Underpass	Manderson	SD	57756	1126	Volunteer coordinator	1980-08-18	1371816816	42.788940	-103.241160	2020	6	21	6
1296674	fraud_Langosh, Wintheiser and Hyatt	food_dining	4.30	Jeffrey	Smith	M	135 Joseph Mountains	Sula	MT	59871	218	Therapist, horticultural	1995-08-16	1371816817	46.565983	-114.186110	2020	6	21	6

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Other Punctuation

Space Separator

Connector Punctuation

Dash Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Connector Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Decimal Number

Space Separator

Other Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks